﻿if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RemindersQueueGetByID]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].RemindersQueueGetByID
GO

CREATE PROCEDURE dbo.RemindersQueueGetByID
(
	@RemindersQueueID int
)
AS

SET NOCOUNT ON

SELECT
	*
FROM 
	RemindersQueue
WHERE
	RemindersQueueID = @RemindersQueueID
	
SELECT
	*
FROM
	RemindersQueueItem
WHERE
	RemindersQueueID = @RemindersQueueID
GO